Data Warehouse Design and Legal Visualization – The Applicability of H2 for Reporting

The steady increase of regulations and its acceleration due to the financial crisis heavily affect the management of regulatory compliance. Regulations, such as Basel III and Solvency II particularly impact data warehouses and lead to many organizational and technical changes. From an IS perspective modeling techniques for data warehouse requirement elicitation help to manage conceptual requirements. From a legal perspective attempts to visualize regulatory requirements – so called legal visualization approaches – have been developed. This paper investigates whether a conceptual modeling technique for regulatory-driven data warehouse requirements is applicable for representing data warehouse requirements in a legal environment. Applying the modeling technique H2 for Reporting in three extensive modeling projects provides three contributions. First, evidence for the applicability of a modeling technique for regulatory-driven data warehouse requirements is given. Second, lessons learned for further modeling projects are provided. Third, a discussion towards a combined perspective of information modeling and legal visualization is presented.